drop table

If you need to drop all tables before you start fresh , you can select the drop table script and execute it .

如果需要在开始刷新之前删除所有表，可以选择并执行删除表脚本。

Finally , the DROP TABLE statement deletes the empty table from the schema .

最后，DROPTABLE语句删除模式中的空表。

Your database user needs quite a lot database permissions , including alter table , drop table , same for index etc.

数据库用户需要相当多的权限，包括修改表格，放下表格，索引一类的也一样。

Note that the debugger might generate warnings related to DROP TABLE statements , which you can ignore .

注意，调试器可能会产生与DROPTABLE语句有关的警告，可以不理会它。

The SQL syntax to delete a table is DROP TABLE followed by the tablename .

删除表的SQL语法是DROPTABLE，这之后是表名。

After copying all rows in table SALES successfully to table SALES_TMP , the source table SALES can be dropped ( DROP TABLE statement ) .

在把SALES表中的所有行成功地复制到SALESTMP表之后，可以删除源表（DROPTABLE语句）。

The syntax is simple : You append the fully qualified name and a semicolon to the DROP TABLE SQL command , and you 're finished .

语法很简单：把完全限定名称和分号放在DROPTABLESQL命令后面，就完成了。

Then use the Drop Table button to drop the table from the database , by adding the selected tablename to the " DROP TABLE " string , as follows

将选定的表名添加到“DROPTABLE”字符串中，然后使用DropTable按钮从数据库中删除该表，如下所示

This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role .

这一技术可能会被用来执行DROPTABLE语句，或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。

To disable an index , you must first drop the table from the publication .

若要禁用索引，必须先从发布中删除该表。

When you drop a table , dropping the table 's triggers should be automatic .

删除表的时候没有自动删除触发器。

The only way to change this relationship is to drop the table and recreate it in a different table space that is tied to a different database partition group .

更改此关系的惟一方式是丢弃此表并在与不同的数据库分区组相关联的一个不同的表空间内重新创建它。

The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up .

在DB2中运行在线备份的惟一约束是：当一个表空间正在被备份的时候，不能删除这个表空间。

Replace & to drop the existing table and then create a new table

替换&放弃已有表并创建一个新表

The merge process could not drop the retry table .

合并进程无法删除重试表。

Determine if you have sufficient access permission to drop the specified table .

确定您是否有足够的访问权限丢弃指定的表。

Drop by my table later .

待会到我的桌子那坐坐。

Drop the existing table and re-create it .

除去现有表并重新创建该表。

With these two buttons and the drop-down ComboBox , you can retrieve the list of tablenames from the IBM DB2 UDB database you 're connected to , and drop the selected table at will .

使用这两个按钮和下拉式ComboBox，可以从连接的IBMDB2UDB数据库中检索表名的列表，并自由删除选中的表。

Database explorer for drag and drop database development and table modification

数据库Explorer用于数据库开发和表格修正中的拖放

To create the table at runtime , set the Table action to drop and recreate the table .

为了在运行时创建表，请设置Table操作来拖放并重新创建表。

To add a metric or dimension to the report , simply drag and drop it into the table .

要添加公制或层面的报告，只要拖放到桌子上。

If you 've already populated your Clients table , you might find it convenient to delete its contents or drop and recreate the table .

如果已经填充了Clients表，那么您可能会发现可以很方便地删除它的内容或销毁并重新创建表。

If you 're indoors , get away from windows , drop under a sturdy table , desk or other protective area and cover your head with a pillow .

如果你在室内，请务必远离窗户，躲在牢固的桌子、凳子或其它有防护物体的区域下，并用枕头保护你的头部。

You create a Statement to execute commands to drop and recreate the table , which allows you to reset the database from this program if it becomes corrupted .

创建一个Statement来执行删除和重新创建表的命令，这允许您在数据库受损时通过此程序重置数据库。

Additional solutions , depending on the errors , may be to manually rebuild non-clustered indexes , manually drop and reload a table if the data is static , and so on .

另外的解决方案，取决于具体的错误，可能是手工重建非聚簇索引，如果数据是静态的手工扔掉和重新载入表，诸如此类。

Okay , now I need some footage of me reacting to Jay 's speech to replace the champagne sneeze , and I 'll just drop that into another table full of people .

接下来要拍摄我听杰演讲时的镜头来替换朝香槟打喷嚏这一段，然后把这段接到另一张一大桌人的图像里。

Saturday's5-3 defeat at Everton was Blackpool 's seventh in eight Premier League games , a run that has seen them drop to15th in the table , just two points above the relegation zone .

周六黑池3-5输给埃弗顿，这是他们8场英超联赛中的第七场失败。连败让他们跌至积分榜第15，仅比降级区高出2分。

The script includes commented drop statements that users can uncomment to drop the table .

该脚本包括已注释掉的撤销语句，用户可以取消对表的撤销。